Microsoft Power BI – The Complete Masterclass
Skill Success
Summary
- Certificate of completion - Free
- Tutor is available to students
Add to basket or enquire
Overview
This course includes lifetime access so you can complete it at your own speed.
Learn the basics of Power BI, all the important tools and when and how to use them properly, and how to visualize your data effectively.
Benefits of taking this course include:
- Unlimited and lifetime access to the course
- Learn the course at your own pace
- Course can be accessed on any platform
- 24/7 Customer support
Course media
Description
Do you want to learn the skills to professionally analyze data?
Do you want to learn all the steps to create impressive reports?
Then Microsoft Power BI is the right tool for you!
In this course you will learn – step by step – everything that is important in Power BI to become an advanced Power BI report creator.
Understand everything from scratch – step by step, very structured and practice-oriented
- Learn all the important tools – know when and how to use them properly
- Connect different data sources – from basics to advanced
- Create your data model – and understand it
- Master DAX – to do more advanced analysis on your data
- Get to know all the different visualizations – and how to use them
- Storytelling with data – learn how to visualize your data effectively
- Create interactive visualizations – with drill throughs and drill downs
- Advanced analysis – learn how to use R Script in Power BI (Data Science)
- Forecasting – Advanced analytics which can be helpful in Data Science
- Row-Level Security – Implement the security concept to control access to the data
This course is right for you if you have never worked with Power BI and want to learn everything hands-on in one course. OR you have already some basic knowledge and want to dive deeper and become more advanced in the whole universe of Power BI.
This is the course that covers everything in Power BI to become an advanced report developer!
Enroll now to get life long access!
Microsoft Power BI – The Complete Masterclass will cover the following topics:
Section 1 - Introduction
- Downloadable Resources – All Source Files
- Welcome!
- What Is Power BI?
- Download And Installing Power BI Desktop
- Getting To Know The Interface
- Mini Project: Transform Data
- Mini Project: Visualize Data
- Mini Project: Creating A Data Model
- Course Outline: What Will You Learn In This Course?
Section 2 - Preparing Our Project
- Creating Our Initial Project File
- Working With The Attached Project Files
Section 3 - Data Transformation - The Query Editor
- Exploring The Query Editor
- Connecting To Our Data Source
- Editing Rows
- Changing Data Types
- Replacing Values
- Close And Apply
- Connecting To A CSV File
- Connecting To A Web Page
- Extracting Characters
- Splitting And Merging Columns
- Creating Conditional Columns
- A Little Note Regarding The Next Lecture
- Creating Columns From Examples
- Merging Queries
- Pivoting And Unpivoting
- Appending Queries
- Practice And Solution: Population Table
- The Fact-Dimension-Model
- Practice: Load The Dimension Table
- Organizing Our Queries In Groups
- Text To Be Used In The Next Lecture
- Entering Data Manually
- Creating An Index Column
- Workflow And More Transformations
- Module Summary
- Exercise 1
- 1 Question
Section 4 - Data Transformation - Advanced
- Advanced Editor – Best Practices
- Performance: References Vs. Duplicating
- Performance: Enable/Disable Load And Report Refresh
- Group By
- Mathematical Operations
- Run R Script
- Using Parameters To Dynamically Transform Data
- M Formula Language: Basics
- M Formula Language: Values, Lists And Tables
- M Formula Language: Functions
- M Formula Language: More Functions And Steps
- Exercise 2 – Instructions
- Exercise 2 – Solution
Section 5 - Creating A Data Model
- Why A Data Model?
- Create And Edit Relationships
- One-To-Many And One-To-One Relationship
- Many-To-Many (M:N) Relationship
- Cross Filter Direction
- Activate And Deactivate Relationships
- Module Summary
- Exercise 3 – Instructions
- Exercise 3 – Solution
Section 6 - Data Visualization
- Our First Visual
- The Format Tab
- Understanding Tables
- Conditional Formatting
- The Pie Chart
- All About The Filter Visual
- The Filter Pane For Developers
- Cross Filtering And Edit Interactions
- Exercise 4 – Instructions
- Exercise 4 – Solution
- Syncing Slicers Across Pages
- Creating Drill Downs
- Creating Drill Throughs
- The Tree Map Visual
- The Decomposition Tree
- Understanding The Matrix Visual
- Editing Pages
- Buttons And Actions
- Bookmarks To Customize Your Report
- Analytics And Forecasts With Line Charts
- Working With Custom Visuals
- Get Data Using R Script And R Script Visual
- R Script To Use
- Asking Questions – Q&A Visual
- Wrap Up – Data Visualization
Section 7 - Power BI And Python
- Python In Power BI – Plan Of Attack
- Setting Up Python For Power BI
- Transforming Data Using Python
- Python Script I Used In The Next Lecture
- Creating Visualizations Using Python
- Python Script II Used In The Next Lecture
- Violin Plots, Pair Plots And Ridge Plots Using Python
- Python Script III Used In The Next Lecture
- Machine Learning (BayesTextAnalyzer) Using Python
- Performance And Troubleshooting
Section 8 - DAX - The Essentials
- Introduction
- The Project Data
- DAX Cheat Sheet
- All Files For The DAX Part
- Measures Vs. Calculated Columns
- Automatically Creating A Date Table In DAX
- CALENDAR
- Creating A Complete Date Table With Features
- Script To Be Used In Your Future Projects
- Creating Key Measure Table
- Aggregation Functions
- The Different Versions Of Count
- SUMX – Row Based Calculations
- DAX Exercise 1
- DAX Solution 1
Section 9 - DAX - The Calculate Function
- CALCULATE – The Basics
- Changing The Context With FILTER
- ALL
- ALLSELECTED
- ALLEXCEPT
- DAX Exercise 2
- DAX Solution 2
Section 10 - Tell A Story With Your Data - Learn To Visualize Effectively
- Intro – Best Practices
- Show Empathy And Identify The Requirements
- Find The Most Suitable KPIs
- Choose An Effective Visual
- Make Use Of Natural Reading Pattern
- Tell A Story Using Visual Cues
- Avoid Chaos And Group Information
- Wrap Up – Storytelling With Data
Section 11 - Power BI Service - Power BI Cloud
- How To Go On Now?
- Power BI Pro Vs Premium And Signing Up
- An Alternative If You Don’t Have A Business Email
- Exploring The Interface
- Discovering Your Workspace
- Little Note On The Next Lecture – Uploading Your Report
- Connecting Power BI Desktop And Cloud
- Understanding Datasets And Reports
- Working On Reports
- Updating Reports From Power BI Desktop
- Creating And Working With Workspaces
- Installing And Using A Data Gateway
- Get Quick Insights
- Creating Dashboards
- Sharing Our Results Through Apps
- Power BI Mobile App
- Creating The Layout For The Mobile App
- Wrap Up – Power BI Cloud
Section 12 - Row-Level Security
- Introduction
- Creating A Row-Level Security
- Row-Level Security In The Cloud
- Row-Level Security And Data Model
- Dynamic Row-Level Security
- Dynamic Many-To-Many RLS
- Hierarchical Row-Level Security
Section 13 - More Data Sources
- JSON And REST API
- Setting Up A Local MYSQL Database
- Connecting To A MYSQL Database In Power Bi
- Connecting To A SQL Database (PostgreSQL)
Section 14 - Next Steps To Improve And Stay Up To Date
- Congratulations And Next Steps
- The End
- More Data To Practice
Who is this course for?
- Anyone who is looking for a complete and comprehensive intro to Power BI
- Everyone who wants to also learn more advanced Power BI skills such as DAX for calculated columns and measures
- Anyone who wants to pursue a career as a data analyst, data scientist or BI consultant
- Anyone who has never used Power BI before and is looking for a hands-on approach to learn it
Requirements
- A computer with Windows operating system
- Power BI Desktop (free download)
- For some modules with Power BI Service (Cloud) account, a school or work email address is required to sign up (free 60 day trial)
Career path
None
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Certificates
Certificate of completion
Digital certificate - Included
Reviews
Add to basket or enquire
Course provided by
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.
